Ì € i 2
sch.res.available.holidays (avail.holidays)
[resource, avail.holiday]
&SR[sr]H[hldy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
avail.holiday 10 FREE L MIS.HOLIDAY hldy
Ì € i 2
SCH resource date comments (date.comments)
[resource, date]
&SR[sr]DC[rdc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 10 DATE L rdc
date.comment 50 FREE L &SR[sr]DC[rdc]|0
Ì € i 2
SCH resource faciltiies (facilities)
[resource, facility]
&SR[sr]FAC[gqb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
facility 10 FREE L MIS.FACILITY gqb
Ì € i 2
SCH resource periods (periods)
[resource, period.start.date]
&SR[sr]P[srps]
Field Name Len Dat Typ J DPM Offset/Local/VAL
period.start.date 8 DATE L srps
period.active 1 YN L &SR[sr]P[srps]|0
period.end.date 8 DATE L &SR[sr]P[srps]|1
Ì € i 2
SCH resource days (days)
[resource,period.start.date, day]
&SR[sr]P[srps]D[srd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
day 3 DAY L srd
day.active 1 YN L &SR[sr]P[srps]D[srd]|0
day.cycle 2 PINT R &SR[sr]P[srps]D[srd]|2
day.frequency.description 30 FREE L &SR[sr]P[srps]D[srd]|3
day.type 7 CHOICE L &SR[sr]P[srps]D[srd]|1
Ì € i 2
SCH resource day month pattern (day.monthly.patterns)
[resource,period.start.date,day, month]
&SR[sr]P[srps]D[srd]M[mth]
Field Name Len Dat Typ J DPM Offset/Local/VAL
month 3 PINT R mth
Ì € i 2
SCH resource day monthly week (day.monthly.weeks)
[resource,period.start.date,day,month, monthly.week]
&SR[sr]P[srps]D[srd]M[mth]W[mweek]
Field Name Len Dat Typ J DPM Offset/Local/VAL
monthly.week 1 CHOICE L mweek
Ì € i 2
SCH resource day weekly patter (day.weekly.patterns)
[resource,period.start.date,day, week]
&SR[sr]P[srps]D[srd]W[wk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
week 3 PINT R wk
Ì € i 2
SCH resource sessions (sessions)
[resource,period.start.date,day, session.start.time]
&SR[sr]P[srps]D[srd]S[srss]
Field Name Len Dat Typ J DPM Offset/Local/VAL
session.start.time 4 ZCUS.MIN L srss
session.active 1 YN L &SR[sr]P[srps]D[srd]S[srss]|0
session.appt.all.same.len 1 YN L &SR[sr]P[srps]D[srd]S[srss]|5
session.def.appt.avail 1 YN L &SR[sr]P[srps]D[srd]S[srss]|4
session.def.appt.bk 2 FREE L &SR[sr]P[srps]D[srd]S[srss]|3
session.def.appt.len 4 PINT R &SR[sr]P[srps]D[srd]S[srss]|2
session.end.time 4 ZCUS.MIN L &SR[sr]P[srps]D[srd]S[srss]|1
session.end.time.ext 4 FREE L VAL=%Z.zcus.uk.min.to.hhmm(@session.end.time)
session.start.time.ext 4 FREE L VAL=%Z.zcus.uk.min.to.hhmm(@session.start.time)
Ì € i 2
SCH resource sessions appts (session.appts)
[resource,period.start.date,day,session.start.time, session.appt.start]
&SR[sr]P[srps]D[srd]S[srss]A[srsa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
session.appt.start 4 ZCUS.MIN L srsa
session.appt.available 1 YN L &SR[sr]P[srps]D[srd]S[srss]A[srsa]|3
session.appt.book.factor 2 FREE L &SR[sr]P[srps]D[srd]S[srss]A[srsa]|2
session.appt.end 4 ZCUS.MIN L &SR[sr]P[srps]D[srd]S[srss]A[srsa]|0
session.appt.length 4 PINT R &SR[sr]P[srps]D[srd]S[srss]A[srsa]|1
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
SCH resource date available [resource,date.available] = period.start.date
dates.available &SRDA[sr,xdate]
dates available by calendar [resource,date.available] = 0
dates.available.cal &SRDAC[sr,xdate]
SCH RESOURCE session index [resource,date,session.start.time] = session.end.time
dates.by.session &SRDAS[sr,rdc,srss]
|
|
| | | | | | | | |